SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
and (bedrooms >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Charming 4-bedroom, 3-bath farmhouse nestled on over 4 acres of open pasture and field. This inviting home blends classic character with modern updates, featuring beautiful hardwood floors, an updated kitchen with plenty of space for cooking and gathering, and comfortable living areas filled with natural light. The additional finished space over the garage offers flexibility for a guest suite, office, or recreation room. Enjoy peaceful local mountain views from the screened in porch or spend evenings by the outdoor firepit, perfect for entertaining or relaxing under the stars. With easy access to town, schools, and all amenities, this property combines the serenity of country living with everyday convenience and plenty of blueberries with over 40 bushes to pick from. Ideal for those seeking room to roam, a place for animals or gardens, and a home designed for comfort and connection. Just minutes from I89, Lebanon green and DHMC plus part of this 4 acres has direct access to the rail trail for walking and biking. Open House Saturday March 28th from 11:30-1:00pm
Description:Bright and sunny four bedroom, two and a half bath home in delightful in-town neighborhood. Wonderful sun room off the family room is a great spot to relax and read. Open floor plan makes for easy communication. Gleaming hardwood floors on living level and bedroom level, carpet in lower level. Near the Appalachian Trail, and just one mile from the Hanover Inn. Super convenient! This is a great one!
Description:Waterfront property in Eastman with seasonal lake views! This beautiful home has been totally updated, including an all new kitchen with granite counter tops, stainless steel appliances, lots of cabinets for storage and a custom breakfast bar at the height for standard chairs. This opens to a separate dining area with a bay window for plenty of natural light. Continue through the open floor plan to a light and bright living room with a gorgeous wood-burning fireplace as the focal point. Retreat to the first-floor primary bedroom suite with an updated bathroom, which includes a separate tub and shower, plus a powder room with its own sink and vanity, and a spacious walk-in closet. Speaking of spacious, the finished lower level walkout has a large family room, flex space/den, 3 more bedrooms, and 2 more updated bathrooms. Completely handicap accessible with an elevator to seamlessly change levels! Other amenities include a generous office with built-ins, first-floor laundry room with built-in storage and counter for folding, convenient first-floor half-bath, radiant heat floors in baths, and direct entry from the 2-car attached garage. Take advantage of the peaceful wooded setting from the screened porch, deck, covered front porch and hot tub. All this in the desirable 4-season community of Eastman in the heart of the Dartmouth - Lake Sunapee Region with easy access to I-89. Enjoy lake activities, golf, XC ski trails, tennis, pickleball, an indoor pool, fitness center and more.
Description:Step into timeless elegance with this extraordinary 1929 Classical Revival home, where historic craftsmanship and gracious living come together beautifully. Period details include ornate plaster moldings, stained and beveled glass windows, quarter-sawn oak floors, rich mahogany doors, extra-high ceilings, a sweeping front staircase, and a classic fireplace that creates a warm, dramatic sense of arrival. Offering nearly 5,000 square feet, the home features five bedrooms and six baths, including four ensuite bedrooms for comfort and privacy. Two expansive porches, including a screened porch, overlook spectacular perennial gardens filled with layered plantings, seasonal blooms, and mature landscaping that provide color and fragrance from spring through fall. Pollinator-friendly varieties attract birds and butterflies, while established borders and intimate garden spaces create a serene, park-like setting ideal for morning coffee, sunset gatherings, and evening stargazing. A charming portico and garage add convenience while preserving architectural character. Ideally located in Historic Shaker Village minutes from Dartmouth College and Dartmouth Health, the property offers rare flexibility. Formerly a successful bed and breakfast and now a single-family residence, it is well suited for elegant private living or renewed hospitality use. Enjoy year-round recreation with nearby lake activities, rail trails, and mountain biking, plus easy access to multiple ski areas including Whaleback, Sunapee, Dartmouth Skiway, and Ragged Mountain, with Killington, Stowe, and Loon about an hour away. Completing this remarkable offering is a peaceful, private meditation chapel — a truly unique retreat space that sets this home apart.
Description:First time on the market, this 4-bedroom, 2.5-bath Colonial in the desirable Blueberry Hill neighborhood has been thoughtfully cared for by its original owners. The home features an open kitchen, living and dining area with beautiful wood flooring throughout the first floor, creating an easy flow for everyday living and entertaining. A spacious screened porch leads to a deck overlooking stunning perennial gardens. Just off the kitchen, enjoy an outdoor hot tub and shower. Step outside and you’ll find direct access to miles of trails from your backyard, perfect for hiking and exploring. Located in New Hampshire's top rated school district. Showings begin on Saturday, March 14 - Open House from 11:00 – 1:00.